A Performance Evaluation of Spatial Join Processing Strategies
نویسندگان
چکیده
We provide an evaluation of query execution plans (QEP) in the case of queries with one or two spatial joins. The QEPs assume R -tree indexed relations and use a common set of spatial joins algorithms, among which one is a novel extension of a strategy based on an on-the-fly index creation prior to the join with another indexed relation. A common platform is used on which a set of spatial access methods and join algorithms are available. The QEPs are implemented with a general iterator-based spatial query processor, allowing for pipelined QEP execution, thus minimizing memory space required for intermediate results.
منابع مشابه
BFRJ: Global Optimization of Spatial Joins Using R-trees
Spatial joins are important operations in applications such as Geographic Information Systems, Cartography, and CAD/CAM. Spatial join using existing R-trees is a very useful and popular technique because of both its superior performance and the wide spread implementation of R-trees as spatial index structures. This paper describes a new spatial join method called BFRJ (BreadthFirst R-tree Join)...
متن کاملProcessing Joins with User-Defined Functions
Most strategies for the computation of relational joins (such as sort-merge or hash-join) are facing major diiculties if the join predicate involves complex, user-deened functions rather than just simple arithmetic comparisons. In this paper, we identify a class of user-deened functions that can be included in a join predicate, such that a join between two sets R and S can still be computed eec...
متن کاملProcessing Joins with User-deened Functions
Most strategies for the computation of relational joins (such as sort-merge or hash-join) are facing major diiculties if the join predicate involves complex, user-deened functions rather than just simple arithmetic comparisons. In this paper, we identify a class of user-deened functions that can be included in a join predicate, such that a join between two sets R and S can still be computed eec...
متن کاملAdaptive and Incremental Processing for Distance Join Queries
A spatial distance join is a relatively new type of operation introduced for spatial and multimedia database applications. Additional requirements for ranking and stopping cardinality are often combined with the spatial distance join in on-line query processing or internet search environments. These requirements pose new challenges as well as opportunities for more efficient processing of spati...
متن کاملAn Experimental Analysis of Iterated Spatial Joins in Main Memory
Many modern applications rely on high-performance processing of spatial data. Examples include location-based services, games, virtual worlds, and scientific simulations such as molecular dynamics and behavioral simulations. These applications deal with large numbers of moving objects that continuously sense their environment, and their data access can often be abstracted as a repeated spatial ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 1999